load data
truncate                                       
into table CRST_PO_HEADERS_ALL
fields terminated by "	"                      
trailing nullcols 
( PO_HEADER_ID                ,
  AGENT_ID                    ,
  TYPE_LOOKUP_CODE            ,
  LAST_UPDATE_DATE            Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY             ,
  SEGMENT1                    ,
  SUMMARY_FLAG                ,
  ENABLED_FLAG                ,
  SEGMENT2                    ,
  SEGMENT3                    ,
  SEGMENT4                    ,
  SEGMENT5                    ,
  START_DATE_ACTIVE           Date "YYYYMMDD HH24:MI:SS",
  END_DATE_ACTIVE             Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATE_LOGIN           ,
  CREATION_DATE               Date "YYYYMMDD HH24:MI:SS",
  CREATED_BY                  ,
  VENDOR_ID                   ,
  VENDOR_SITE_ID              ,
  VENDOR_CONTACT_ID           ,
  SHIP_TO_LOCATION_ID         ,
  BILL_TO_LOCATION_ID         ,
  TERMS_ID                    ,
  SHIP_VIA_LOOKUP_CODE        ,
  FOB_LOOKUP_CODE             ,
  FREIGHT_TERMS_LOOKUP_CODE   ,
  STATUS_LOOKUP_CODE          ,
  CURRENCY_CODE               ,
  RATE_TYPE                   ,
  RATE_DATE                   Date "YYYYMMDD HH24:MI:SS",
  RATE                        ,
  FROM_HEADER_ID              ,
  FROM_TYPE_LOOKUP_CODE       ,
  START_DATE                  Date "YYYYMMDD HH24:MI:SS",
  END_DATE                    Date "YYYYMMDD HH24:MI:SS",
  BLANKET_TOTAL_AMOUNT        ,
  AUTHORIZATION_STATUS        ,
  REVISION_NUM                ,
  REVISED_DATE                Date "YYYYMMDD HH24:MI:SS",
  APPROVED_FLAG               ,
  APPROVED_DATE               Date "YYYYMMDD HH24:MI:SS",
  AMOUNT_LIMIT                ,
  MIN_RELEASE_AMOUNT          ,
  NOTE_TO_AUTHORIZER          ,
  NOTE_TO_VENDOR              ,
  NOTE_TO_RECEIVER            ,
  PRINT_COUNT                 ,
  PRINTED_DATE                Date "YYYYMMDD HH24:MI:SS",
  VENDOR_ORDER_NUM            ,
  CONFIRMING_ORDER_FLAG       ,
  COMMENTS                    ,
  REPLY_DATE                  Date "YYYYMMDD HH24:MI:SS",
  REPLY_METHOD_LOOKUP_CODE    ,
  RFQ_CLOSE_DATE              Date "YYYYMMDD HH24:MI:SS",
  QUOTE_TYPE_LOOKUP_CODE      ,
  QUOTATION_CLASS_CODE        ,
  QUOTE_WARNING_DELAY_UNIT    ,
  QUOTE_WARNING_DELAY         ,
  QUOTE_VENDOR_QUOTE_NUMBER   ,
  ACCEPTANCE_REQUIRED_FLAG    ,
  ACCEPTANCE_DUE_DATE         Date "YYYYMMDD HH24:MI:SS",
  CLOSED_DATE                 Date "YYYYMMDD HH24:MI:SS",
  USER_HOLD_FLAG              ,
  APPROVAL_REQUIRED_FLAG      ,
  CANCEL_FLAG                 ,
  FIRM_STATUS_LOOKUP_CODE     ,
  FIRM_DATE                   ,
  FROZEN_FLAG                 ,
  SUPPLY_AGREEMENT_FLAG       ,
  EDI_PROCESSED_FLAG          ,
  EDI_PROCESSED_STATUS        ,
  ATTRIBUTE_CATEGORY          ,
  ATTRIBUTE1                  ,
  ATTRIBUTE2                  ,
  ATTRIBUTE3                  ,
  ATTRIBUTE4                  ,
  ATTRIBUTE5                  ,
  ATTRIBUTE6                  ,
  ATTRIBUTE7                  ,
  ATTRIBUTE8                  ,
  ATTRIBUTE9                  ,
  ATTRIBUTE10                 ,
  ATTRIBUTE11                 ,
  ATTRIBUTE12                 ,
  ATTRIBUTE13                 ,
  ATTRIBUTE14                 ,
  ATTRIBUTE15                 ,
  CLOSED_CODE                 ,
  USSGL_TRANSACTION_CODE      ,
  GOVERNMENT_CONTEXT          ,
  REQUEST_ID                  ,
  PROGRAM_APPLICATION_ID      ,
  PROGRAM_ID                  ,
  PROGRAM_UPDATE_DATE         Date "YYYYMMDD HH24:MI:SS",
  ORG_ID                      ,
  GLOBAL_ATTRIBUTE_CATEGORY   ,
  GLOBAL_ATTRIBUTE1           ,
  GLOBAL_ATTRIBUTE2           ,
  GLOBAL_ATTRIBUTE3           ,
  GLOBAL_ATTRIBUTE4           ,
  GLOBAL_ATTRIBUTE5           ,
  GLOBAL_ATTRIBUTE6           ,
  GLOBAL_ATTRIBUTE7           ,
  GLOBAL_ATTRIBUTE8           ,
  GLOBAL_ATTRIBUTE9           ,
  GLOBAL_ATTRIBUTE10          ,
  GLOBAL_ATTRIBUTE11          ,
  GLOBAL_ATTRIBUTE12          ,
  GLOBAL_ATTRIBUTE13          ,
  GLOBAL_ATTRIBUTE14          ,
  GLOBAL_ATTRIBUTE15          ,
  GLOBAL_ATTRIBUTE16          ,
  GLOBAL_ATTRIBUTE17          ,
  GLOBAL_ATTRIBUTE18          ,
  GLOBAL_ATTRIBUTE19          ,
  GLOBAL_ATTRIBUTE20          ,
  INTERFACE_SOURCE_CODE       ,
  REFERENCE_NUM               ,
  WF_ITEM_TYPE                ,
  WF_ITEM_KEY                 ,
  MRC_RATE_TYPE               ,
  MRC_RATE_DATE               Date "YYYYMMDD HH24:MI:SS",
  MRC_RATE                    ,
  PCARD_ID                    ,
  PRICE_UPDATE_TOLERANCE      ,
  PAY_ON_CODE                 ,
  XML_FLAG                    ,
  XML_SEND_DATE               Date "YYYYMMDD HH24:MI:SS",
  XML_CHANGE_SEND_DATE        Date "YYYYMMDD HH24:MI:SS",
  GLOBAL_AGREEMENT_FLAG       ,
  CONSIGNED_CONSUMPTION_FLAG  ,
  CBC_ACCOUNTING_DATE         Date "YYYYMMDD HH24:MI:SS",
  CONSUME_REQ_DEMAND_FLAG     ,
  CHANGE_REQUESTED_BY 
)
